package com.chh.exam.survey.mapper;

import com.chh.exam.survey.entity.SurveyUserScore;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author xiaochen
* @description 针对表【wj_survey_user_score】的数据库操作Mapper
* @createDate 2025-01-08 15:23:54
* @Entity com.chh.exam.survey.entity.SurveyUserScore
*/
public interface SurveyUserScoreMapper extends BaseMapper<SurveyUserScore> {

    @Select("select * from wj_survey_user_score where survey_id = #{survey_id} order by score desc, exam_duration asc")
    List<SurveyUserScore> getExamRangking(Integer surveyId);
}




